Attribute | Description | Physical Name | Domain | Data Type | Foreign Key Table |
ItemCountryOriginID (PK) | A token used to identify an object, represented as an Integer. | ID_CY_ORG | Identity | integer | |
CountryOriginTypeCode (FK) | A code that identifies the country of origin. The ISO country code standard is recommended as the value list for this attribute type. | CD_CY_ORG | ISOCountryCode | CHAR(3) | CountryOriginRoleType(LU_CY_ORG_RO_TY) |
ISOCountryCode (FK) | The ISO-3166-1 two letter code denoting a locality in which the retailer does business. | CD_CY_ISO | Code2 | char(2) | ISO3166-1Country(LO_CY_ISO) |
ItemTraceableUnitID (FK) | A universally unique identifier used to identify an instance of a distinguisable instance of a retail item. The item traceable unit ID is similar to a serial number in that it allows each selling unit to be explicitly identified and distinguished from other sellling units of the same Item. | ID_ITM_UN_TRC | IdentityUUID | CHAR(32) | ItemTraceableUnit(AS_ITM_TRCBL_UN) |